Hệ thống quản lý phương tiện trực tuyến bằng PHP

7.266 lượt xem;

empaccount.php
project /

1 <?php
2 ob_start();
3 include("header.php");
4 include("sidebar.php");
5 include("dbconnection.php");
6 if(isset($_SESSION[custid]))
7 {
8     header("Location: account.php");
9 }
10 ?>
11 <div id="main">
12         <h3>Employee Home Page</h3>
13
14
15   <table width="539" border="1">
16     <tr>
17       <td width="382" height="45" align="center" valign="middle"><strong>No. of customers</strong></td>
18
19       <td width="141" align="center" valign="middle">
20         <strong>
21         <?php
22 $sqlcount = mysql_query("select * from customer");
23 echo mysql_num_rows($sqlcount);
24 ?>
25       </strong></td>
26     </tr>
27     <tr>
28       <td height="42" align="center" valign="middle"><strong>Number of vehicle service requests</strong></td>
29       <td align="center" valign="middle">
30         <strong>
31         <?php
32 $sqlcount = mysql_query("select * from service where status='Pending'");
33 echo mysql_num_rows($sqlcount);
34 ?>
35       </strong></td>
36     </tr>
37
38     <tr>
39       <td height="40" align="center" valign="middle"><strong>Spare parts orders</strong></td>
40       <td align="center" valign="middle">
41         <strong>
42         <?php
43             $sqlcount = mysql_query("select * from sparepartsorder where deliverydate='0000-00-00'");
44             echo mysql_num_rows($sqlcount);
45             ?>
46       </strong></td>
47     </tr>
48
49     <tr>
50       <td height="33" align="center" valign="middle"><strong>Used vehicles</strong></td>
51       <td align="center" valign="middle"><strong>
52         <?php
53             $sqlcount = mysql_query("select * from vehicle where status ='Pending'");
54             echo mysql_num_rows($sqlcount);
55             ?>
56       </strong></td>
57     </tr>
58     <tr>
59       <td height="40" align="center" valign="middle"><strong>No. of vehices in Vehicle store</strong></td>
60       <td align="center" valign="middle">
61         <strong>
62         <?php
63            $sqlcount = mysql_query("select * from vehiclestore where status !='Sold'");
64             echo mysql_num_rows($sqlcount);
65             ?>
66       </strong></td>
67     </tr>
68     <tr>
69       <td height="35" align="center" valign="middle"><strong>No. of test drive requests</strong></td>
70       <td align="center" valign="middle"> <strong>
71         <?php
72            $sqlcount = mysql_query("select * from testdrive where status ='Pending'");
73             echo mysql_num_rows($sqlcount);
74             ?>
75       </strong></td>
76     </tr>
77   </table>
78   </div>
79
80 
81 </div>
82
83 <?php
84 include("footer.php");
85 ?>